﻿CREATE TABLE [dbo].[thist_Root] (
    [HID]        BIGINT         IDENTITY (1, 1) NOT NULL,
    [BatchHID]   BIGINT         NULL,
    [UserName]   VARCHAR (50)   NOT NULL,
    [DateStamp]  DATETIME       NOT NULL,
    [ObjectName] VARCHAR (128)  NOT NULL,
    [Type]       CHAR (1)       NOT NULL,
    [PK_1]       NVARCHAR (256) NOT NULL,
    [PK_2]       NVARCHAR (256) NULL,
    [PK_3]       NVARCHAR (256) NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0-archive,1-update,2-delete', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'thist_Root', @level2type = N'COLUMN', @level2name = N'Type';

